import sqlite3


conn = sqlite3.connect('./DB/libSys.db')
cursor = conn.cursor()

# 作者信息
# sql = "create table author( authorid INTEGER PRIMARY KEY AUTOINCREMENT, author_name Text NOT NULL )"
# 类别信息
# sql = "create table category( categoryid INTEGER PRIMARY KEY AUTOINCREMENT, category_name Text NOT NULL )"
# 出版社信息
sql = "create table press( pressid INTEGER PRIMARY KEY AUTOINCREMENT, press_name Text NOT NULL )"




cursor.execute(sql)

# insert_sql = 'insert into author(author_name) values ("Jack"),("Pual"),("Tom")'
# 类别
# insert_sql = 'insert into category(category_name) values ("历史"),("人文"),("数学")'
#
# cursor.execute(insert_sql)
# conn.commit()
conn.close()